package com.crm.dao.before_sale;

import com.crm.pojo.Scheme;
import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
import org.springframework.data.jpa.repository.Modifying;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.CrudRepository;

public interface SchemeDAO extends CrudRepository<Scheme,Long>, JpaSpecificationExecutor<Scheme> {
    //逻辑删除需求
    @Query(nativeQuery = true,value = "update SCHEME set SCHEME_IS_DEL='是' where SC_ID=?1")
    @Modifying
    public void deleteSchemeById(Long needId);
}
